HTTP Tunneling is a method for connecting to a MySQL/PostgreSQL/SQLite server that uses the same protocol (http://) and the same port (port 80) as a webserver does. It is used while your ISPs do not allow direct connections to their MySQL/PostgreSQL/SQLite server, but allows establishing HTTP connections.
Steps of setting up HTTP Connection for MySQL/PostgreSQL/SQLite:
- Uploading the Tunneling Script
To use this connection method, first thing you need to do is to upload the tunneling script - ntunnel_mysql.php, ntunnel_pgsql.php or ntunnel_sqlite.php to the webserver where MySQL, PostgreSQL or SQLite server is located.
Note: ntunnel_mysql.php, ntunnel_pgsql.php or ntunnel_sqlite.php is available in the Navicat installation package. - Setting up HTTP Tunnel
The following instruction guides you through the process of configuring a HTTP connection.
- Click
or click
-> New Connection under the navigation pane or choose Connection -> New Connection to set up the Connection Properties.
- Select the HTTP tab and enable Use HTTP tunnel.
- Enter URL of the tunneling script, e.g. http://www.navicat.com/ntunnel_mysql.php .
- If the ntunnel_mysql.php, ntunnel_pgsql.php or ntunnel_sqlite.php is hosted in a password protected server, you can provide the required authentication details.
- Navicat host name at the General Settings page (MySQL, PostgreSQL or SQLite) should be set relatively to the HTTP server which provided by your database hosting company.
- Click
Note: HTTP Tunnel and SSH Tunnel cannot function simultaneously. The SSH Tunnel is disabled when you select the HTTP Tunnel and vice versa.
See also:
Advanced Settings
Related topics:
General Settings for MySQL
General Settings for PostgreSQL
General Settings for SQLite